{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<style>.container { width:100% !important; }</style>"
      ],
      "text/plain": [
       "<IPython.core.display.HTML object>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "from IPython.core.display import display, HTML\n",
    "display(HTML(\"<style>.container { width:100% !important; }</style>\"))\n",
    "from strategy.base_strategy import *\n",
    "from utils.jsl_data_map import columns_map"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 55,
   "metadata": {},
   "outputs": [],
   "source": [
    "format_dict = {\n",
    "    '现价':'{0:.3f}',\n",
    "    '涨跌幅':'{0:.2f}%',\n",
    "    '近5日涨跌幅':'{0:.2f}%',\n",
    "    '近20日涨跌幅':'{0:.2f}%',\n",
    "    '近3月涨跌幅':'{0:.2f}%',\n",
    "    '近1年涨跌幅':'{0:.2f}%',\n",
    "    '溢价率':'{0:.2f}%',\n",
    "    '剩余规模':'{0:.3f}',\n",
    "    '正股涨跌':'{0:.2f}%',\n",
    "    '成交额':'{0:.2f}',\n",
    "\n",
    "}"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "按交易量排序\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<style  type=\"text/css\" >\n",
       "#T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row4_col2{\n",
       "            background-color:  yellow;\n",
       "        }</style><table id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3\" ><thead>    <tr>        <th class=\"col_heading level0 col0\" >转债名称</th>        <th class=\"col_heading level0 col1\" >转债代码</th>        <th class=\"col_heading level0 col2\" >现价</th>        <th class=\"col_heading level0 col3\" >涨跌幅</th>        <th class=\"col_heading level0 col4\" >近5日涨跌幅</th>        <th class=\"col_heading level0 col5\" >近20日涨跌幅</th>        <th class=\"col_heading level0 col6\" >近3月涨跌幅</th>        <th class=\"col_heading level0 col7\" >近1年涨跌幅</th>        <th class=\"col_heading level0 col8\" >溢价率</th>        <th class=\"col_heading level0 col9\" >剩余规模</th>        <th class=\"col_heading level0 col10\" >行业</th>        <th class=\"col_heading level0 col11\" >正股名称</th>        <th class=\"col_heading level0 col12\" >正股涨跌</th>        <th class=\"col_heading level0 col13\" >成交额</th>    </tr></thead><tbody>\n",
       "                <tr>\n",
       "                                <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row0_col0\" class=\"data row0 col0\" >思特转债</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row0_col1\" class=\"data row0 col1\" >123054</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row0_col2\" class=\"data row0 col2\" >167.500</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row0_col3\" class=\"data row0 col3\" >7.37%</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row0_col4\" class=\"data row0 col4\" >19.83%</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row0_col5\" class=\"data row0 col5\" >18.79%</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row0_col6\" class=\"data row0 col6\" >21.94%</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row0_col7\" class=\"data row0 col7\" >32.20%</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row0_col8\" class=\"data row0 col8\" >-0.68%</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row0_col9\" class=\"data row0 col9\" >2.002</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row0_col10\" class=\"data row0 col10\" >垂直应用软件</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row0_col11\" class=\"data row0 col11\" >思特奇</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row0_col12\" class=\"data row0 col12\" >6.45%</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row0_col13\" class=\"data row0 col13\" >469682.43</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                                <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row1_col0\" class=\"data row1 col0\" >润达转债</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row1_col1\" class=\"data row1 col1\" >113588</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row1_col2\" class=\"data row1 col2\" >200.055</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row1_col3\" class=\"data row1 col3\" >18.72%</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row1_col4\" class=\"data row1 col4\" >32.02%</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row1_col5\" class=\"data row1 col5\" >41.13%</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row1_col6\" class=\"data row1 col6\" >42.41%</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row1_col7\" class=\"data row1 col7\" >69.52%</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row1_col8\" class=\"data row1 col8\" >7.32%</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row1_col9\" class=\"data row1 col9\" >4.079</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row1_col10\" class=\"data row1 col10\" >医药流通</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row1_col11\" class=\"data row1 col11\" >润达医疗</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row1_col12\" class=\"data row1 col12\" >10.00%</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row1_col13\" class=\"data row1 col13\" >428907.68</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                                <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row2_col0\" class=\"data row2 col0\" >豪美转债</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row2_col1\" class=\"data row2 col1\" >127053</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row2_col2\" class=\"data row2 col2\" >161.000</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row2_col3\" class=\"data row2 col3\" >-3.59%</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row2_col4\" class=\"data row2 col4\" >28.53%</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row2_col5\" class=\"data row2 col5\" >28.73%</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row2_col6\" class=\"data row2 col6\" >27.84%</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row2_col7\" class=\"data row2 col7\" >42.60%</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row2_col8\" class=\"data row2 col8\" >1.94%</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row2_col9\" class=\"data row2 col9\" >8.238</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row2_col10\" class=\"data row2 col10\" >铝</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row2_col11\" class=\"data row2 col11\" >豪美新材</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row2_col12\" class=\"data row2 col12\" >10.00%</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row2_col13\" class=\"data row2 col13\" >301434.14</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                                <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row3_col0\" class=\"data row3 col0\" >中富转债</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row3_col1\" class=\"data row3 col1\" >123226</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row3_col2\" class=\"data row3 col2\" >201.000</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row3_col3\" class=\"data row3 col3\" >5.24%</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row3_col4\" class=\"data row3 col4\" >101.00%</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row3_col5\" class=\"data row3 col5\" >101.00%</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row3_col6\" class=\"data row3 col6\" >101.00%</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row3_col7\" class=\"data row3 col7\" >101.00%</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row3_col8\" class=\"data row3 col8\" >123.85%</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row3_col9\" class=\"data row3 col9\" >5.200</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row3_col10\" class=\"data row3 col10\" >印制电路板</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row3_col11\" class=\"data row3 col11\" >中富电路</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row3_col12\" class=\"data row3 col12\" >-3.05%</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row3_col13\" class=\"data row3 col13\" >235238.16</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                                <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row4_col0\" class=\"data row4 col0\" >广电转债</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row4_col1\" class=\"data row4 col1\" >110044</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row4_col2\" class=\"data row4 col2\" >220.462</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row4_col3\" class=\"data row4 col3\" >5.73%</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row4_col4\" class=\"data row4 col4\" >8.64%</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row4_col5\" class=\"data row4 col5\" >-8.95%</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row4_col6\" class=\"data row4 col6\" >9.55%</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row4_col7\" class=\"data row4 col7\" >15.11%</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row4_col8\" class=\"data row4 col8\" >158.79%</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row4_col9\" class=\"data row4 col9\" >0.706</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row4_col10\" class=\"data row4 col10\" >电视广播</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row4_col11\" class=\"data row4 col11\" >广电网络</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row4_col12\" class=\"data row4 col12\" >-2.19%</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row4_col13\" class=\"data row4 col13\" >201124.09</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                                <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row5_col0\" class=\"data row5 col0\" >锋龙转债</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row5_col1\" class=\"data row5 col1\" >128143</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row5_col2\" class=\"data row5 col2\" >141.900</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row5_col3\" class=\"data row5 col3\" >-14.78%</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row5_col4\" class=\"data row5 col4\" >9.14%</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row5_col5\" class=\"data row5 col5\" >13.76%</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row5_col6\" class=\"data row5 col6\" >14.99%</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row5_col7\" class=\"data row5 col7\" >18.79%</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row5_col8\" class=\"data row5 col8\" >-3.33%</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row5_col9\" class=\"data row5 col9\" >1.780</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row5_col10\" class=\"data row5 col10\" >金属制品</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row5_col11\" class=\"data row5 col11\" >锋龙股份</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row5_col12\" class=\"data row5 col12\" >-10.00%</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row5_col13\" class=\"data row5 col13\" >163132.48</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                                <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row6_col0\" class=\"data row6 col0\" >金农转债</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row6_col1\" class=\"data row6 col1\" >128036</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row6_col2\" class=\"data row6 col2\" >200.000</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row6_col3\" class=\"data row6 col3\" >-1.13%</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row6_col4\" class=\"data row6 col4\" >32.94%</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row6_col5\" class=\"data row6 col5\" >32.08%</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row6_col6\" class=\"data row6 col6\" >32.63%</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row6_col7\" class=\"data row6 col7\" >52.34%</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row6_col8\" class=\"data row6 col8\" >115.19%</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row6_col9\" class=\"data row6 col9\" >1.455</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row6_col10\" class=\"data row6 col10\" >畜禽饲料</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row6_col11\" class=\"data row6 col11\" >金新农</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row6_col12\" class=\"data row6 col12\" >-1.10%</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row6_col13\" class=\"data row6 col13\" >104023.13</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                                <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row7_col0\" class=\"data row7 col0\" >红墙转债</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row7_col1\" class=\"data row7 col1\" >127094</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row7_col2\" class=\"data row7 col2\" >134.798</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row7_col3\" class=\"data row7 col3\" >-6.39%</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row7_col4\" class=\"data row7 col4\" >34.80%</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row7_col5\" class=\"data row7 col5\" >34.80%</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row7_col6\" class=\"data row7 col6\" >34.80%</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row7_col7\" class=\"data row7 col7\" >34.80%</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row7_col8\" class=\"data row7 col8\" >39.67%</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row7_col9\" class=\"data row7 col9\" >3.160</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row7_col10\" class=\"data row7 col10\" >其他化学制品</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row7_col11\" class=\"data row7 col11\" >红墙股份</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row7_col12\" class=\"data row7 col12\" >-1.31%</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row7_col13\" class=\"data row7 col13\" >92379.19</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                                <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row8_col0\" class=\"data row8 col0\" >大叶转债</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row8_col1\" class=\"data row8 col1\" >123205</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row8_col2\" class=\"data row8 col2\" >169.021</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row8_col3\" class=\"data row8 col3\" >0.61%</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row8_col4\" class=\"data row8 col4\" >13.24%</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row8_col5\" class=\"data row8 col5\" >2.69%</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row8_col6\" class=\"data row8 col6\" >-10.46%</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row8_col7\" class=\"data row8 col7\" >69.02%</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row8_col8\" class=\"data row8 col8\" >88.84%</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row8_col9\" class=\"data row8 col9\" >4.760</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row8_col10\" class=\"data row8 col10\" >农用机械</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row8_col11\" class=\"data row8 col11\" >大叶股份</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row8_col12\" class=\"data row8 col12\" >-2.24%</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row8_col13\" class=\"data row8 col13\" >89830.52</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                                <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row9_col0\" class=\"data row9 col0\" >震裕转债</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row9_col1\" class=\"data row9 col1\" >123228</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row9_col2\" class=\"data row9 col2\" >118.954</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row9_col3\" class=\"data row9 col3\" >18.95%</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row9_col4\" class=\"data row9 col4\" >0.00%</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row9_col5\" class=\"data row9 col5\" >0.00%</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row9_col6\" class=\"data row9 col6\" >0.00%</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row9_col7\" class=\"data row9 col7\" >0.00%</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row9_col8\" class=\"data row9 col8\" >24.71%</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row9_col9\" class=\"data row9 col9\" >11.950</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row9_col10\" class=\"data row9 col10\" >锂电池</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row9_col11\" class=\"data row9 col11\" >震裕科技</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row9_col12\" class=\"data row9 col12\" >-0.20%</td>\n",
       "                        <td id=\"T_e3b8614a_8a96_11ee_98c1_70a6ccf921e3row9_col13\" class=\"data row9 col13\" >85781.28</td>\n",
       "            </tr>\n",
       "    </tbody></table>"
      ],
      "text/plain": [
       "<pandas.io.formats.style.Styler at 0x24df4b2a2b0>"
      ]
     },
     "execution_count": 56,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "rank = VolumeRank()\n",
    "rank_data = rank.api()\n",
    "rank_data.rename(columns=columns_map,inplace=True)\n",
    "# rank_data.style.bar(subset=['现价', '溢价率'], color='#FFA500')\n",
    "# rank_data.style.bar(subset=['price','premium_rt'], color='#FFA500')\n",
    "print(\"按交易量排序\")\n",
    "rank_data.style.hide_index().format(format_dict).highlight_max(axis=0,subset=['现价'])\n",
    "\n",
    "# 按照交易量排序"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "按涨幅排序\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<style  type=\"text/css\" >\n",
       "#T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row3_col2{\n",
       "            background-color:  yellow;\n",
       "        }</style><table id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3\" ><thead>    <tr>        <th class=\"col_heading level0 col0\" >转债名称</th>        <th class=\"col_heading level0 col1\" >转债代码</th>        <th class=\"col_heading level0 col2\" >现价</th>        <th class=\"col_heading level0 col3\" >涨跌幅</th>        <th class=\"col_heading level0 col4\" >近5日涨跌幅</th>        <th class=\"col_heading level0 col5\" >近20日涨跌幅</th>        <th class=\"col_heading level0 col6\" >近3月涨跌幅</th>        <th class=\"col_heading level0 col7\" >近1年涨跌幅</th>        <th class=\"col_heading level0 col8\" >溢价率</th>        <th class=\"col_heading level0 col9\" >剩余规模</th>        <th class=\"col_heading level0 col10\" >行业</th>        <th class=\"col_heading level0 col11\" >正股名称</th>        <th class=\"col_heading level0 col12\" >正股涨跌</th>        <th class=\"col_heading level0 col13\" >成交额</th>    </tr></thead><tbody>\n",
       "                <tr>\n",
       "                                <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row0_col0\" class=\"data row0 col0\" >震裕转债</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row0_col1\" class=\"data row0 col1\" >123228</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row0_col2\" class=\"data row0 col2\" >118.954</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row0_col3\" class=\"data row0 col3\" >18.95%</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row0_col4\" class=\"data row0 col4\" >0.00%</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row0_col5\" class=\"data row0 col5\" >0.00%</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row0_col6\" class=\"data row0 col6\" >0.00%</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row0_col7\" class=\"data row0 col7\" >0.00%</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row0_col8\" class=\"data row0 col8\" >24.71%</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row0_col9\" class=\"data row0 col9\" >11.950</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row0_col10\" class=\"data row0 col10\" >锂电池</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row0_col11\" class=\"data row0 col11\" >震裕科技</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row0_col12\" class=\"data row0 col12\" >-0.20%</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row0_col13\" class=\"data row0 col13\" >85781.28</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                                <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row1_col0\" class=\"data row1 col0\" >润达转债</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row1_col1\" class=\"data row1 col1\" >113588</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row1_col2\" class=\"data row1 col2\" >200.055</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row1_col3\" class=\"data row1 col3\" >18.72%</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row1_col4\" class=\"data row1 col4\" >32.02%</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row1_col5\" class=\"data row1 col5\" >41.13%</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row1_col6\" class=\"data row1 col6\" >42.41%</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row1_col7\" class=\"data row1 col7\" >69.52%</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row1_col8\" class=\"data row1 col8\" >7.32%</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row1_col9\" class=\"data row1 col9\" >4.079</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row1_col10\" class=\"data row1 col10\" >医药流通</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row1_col11\" class=\"data row1 col11\" >润达医疗</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row1_col12\" class=\"data row1 col12\" >10.00%</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row1_col13\" class=\"data row1 col13\" >428907.68</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                                <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row2_col0\" class=\"data row2 col0\" >思特转债</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row2_col1\" class=\"data row2 col1\" >123054</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row2_col2\" class=\"data row2 col2\" >167.500</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row2_col3\" class=\"data row2 col3\" >7.37%</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row2_col4\" class=\"data row2 col4\" >19.83%</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row2_col5\" class=\"data row2 col5\" >18.79%</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row2_col6\" class=\"data row2 col6\" >21.94%</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row2_col7\" class=\"data row2 col7\" >32.20%</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row2_col8\" class=\"data row2 col8\" >-0.68%</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row2_col9\" class=\"data row2 col9\" >2.002</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row2_col10\" class=\"data row2 col10\" >垂直应用软件</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row2_col11\" class=\"data row2 col11\" >思特奇</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row2_col12\" class=\"data row2 col12\" >6.45%</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row2_col13\" class=\"data row2 col13\" >469682.43</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                                <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row3_col0\" class=\"data row3 col0\" >广电转债</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row3_col1\" class=\"data row3 col1\" >110044</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row3_col2\" class=\"data row3 col2\" >220.462</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row3_col3\" class=\"data row3 col3\" >5.73%</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row3_col4\" class=\"data row3 col4\" >8.64%</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row3_col5\" class=\"data row3 col5\" >-8.95%</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row3_col6\" class=\"data row3 col6\" >9.55%</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row3_col7\" class=\"data row3 col7\" >15.11%</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row3_col8\" class=\"data row3 col8\" >158.79%</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row3_col9\" class=\"data row3 col9\" >0.706</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row3_col10\" class=\"data row3 col10\" >电视广播</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row3_col11\" class=\"data row3 col11\" >广电网络</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row3_col12\" class=\"data row3 col12\" >-2.19%</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row3_col13\" class=\"data row3 col13\" >201124.09</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                                <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row4_col0\" class=\"data row4 col0\" >中富转债</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row4_col1\" class=\"data row4 col1\" >123226</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row4_col2\" class=\"data row4 col2\" >201.000</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row4_col3\" class=\"data row4 col3\" >5.24%</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row4_col4\" class=\"data row4 col4\" >101.00%</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row4_col5\" class=\"data row4 col5\" >101.00%</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row4_col6\" class=\"data row4 col6\" >101.00%</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row4_col7\" class=\"data row4 col7\" >101.00%</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row4_col8\" class=\"data row4 col8\" >123.85%</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row4_col9\" class=\"data row4 col9\" >5.200</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row4_col10\" class=\"data row4 col10\" >印制电路板</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row4_col11\" class=\"data row4 col11\" >中富电路</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row4_col12\" class=\"data row4 col12\" >-3.05%</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row4_col13\" class=\"data row4 col13\" >235238.16</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                                <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row5_col0\" class=\"data row5 col0\" >迪贝转债</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row5_col1\" class=\"data row5 col1\" >113546</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row5_col2\" class=\"data row5 col2\" >136.835</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row5_col3\" class=\"data row5 col3\" >5.10%</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row5_col4\" class=\"data row5 col4\" >9.17%</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row5_col5\" class=\"data row5 col5\" >7.58%</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row5_col6\" class=\"data row5 col6\" >9.63%</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row5_col7\" class=\"data row5 col7\" >15.99%</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row5_col8\" class=\"data row5 col8\" >12.55%</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row5_col9\" class=\"data row5 col9\" >2.297</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row5_col10\" class=\"data row5 col10\" >电机</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row5_col11\" class=\"data row5 col11\" >迪贝电气</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row5_col12\" class=\"data row5 col12\" >10.03%</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row5_col13\" class=\"data row5 col13\" >53436.51</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                                <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row6_col0\" class=\"data row6 col0\" >阳谷转债</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row6_col1\" class=\"data row6 col1\" >123211</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row6_col2\" class=\"data row6 col2\" >123.696</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row6_col3\" class=\"data row6 col3\" >2.86%</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row6_col4\" class=\"data row6 col4\" >3.25%</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row6_col5\" class=\"data row6 col5\" >-2.78%</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row6_col6\" class=\"data row6 col6\" >23.70%</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row6_col7\" class=\"data row6 col7\" >23.70%</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row6_col8\" class=\"data row6 col8\" >23.57%</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row6_col9\" class=\"data row6 col9\" >6.500</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row6_col10\" class=\"data row6 col10\" >橡胶助剂</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row6_col11\" class=\"data row6 col11\" >阳谷华泰</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row6_col12\" class=\"data row6 col12\" >6.81%</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row6_col13\" class=\"data row6 col13\" >15499.97</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                                <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row7_col0\" class=\"data row7 col0\" >宇邦转债</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row7_col1\" class=\"data row7 col1\" >123224</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row7_col2\" class=\"data row7 col2\" >127.670</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row7_col3\" class=\"data row7 col3\" >2.85%</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row7_col4\" class=\"data row7 col4\" >10.44%</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row7_col5\" class=\"data row7 col5\" >27.67%</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row7_col6\" class=\"data row7 col6\" >27.67%</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row7_col7\" class=\"data row7 col7\" >27.67%</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row7_col8\" class=\"data row7 col8\" >30.31%</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row7_col9\" class=\"data row7 col9\" >5.000</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row7_col10\" class=\"data row7 col10\" >光伏辅材</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row7_col11\" class=\"data row7 col11\" >宇邦新材</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row7_col12\" class=\"data row7 col12\" >6.19%</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row7_col13\" class=\"data row7 col13\" >39412.06</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                                <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row8_col0\" class=\"data row8 col0\" >平煤转债</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row8_col1\" class=\"data row8 col1\" >113066</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row8_col2\" class=\"data row8 col2\" >125.989</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row8_col3\" class=\"data row8 col3\" >2.51%</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row8_col4\" class=\"data row8 col4\" >2.48%</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row8_col5\" class=\"data row8 col5\" >0.30%</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row8_col6\" class=\"data row8 col6\" >7.97%</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row8_col7\" class=\"data row8 col7\" >25.99%</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row8_col8\" class=\"data row8 col8\" >8.50%</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row8_col9\" class=\"data row8 col9\" >28.999</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row8_col10\" class=\"data row8 col10\" >焦煤</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row8_col11\" class=\"data row8 col11\" >平煤股份</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row8_col12\" class=\"data row8 col12\" >7.13%</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row8_col13\" class=\"data row8 col13\" >29803.93</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                                <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row9_col0\" class=\"data row9 col0\" >润禾转债</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row9_col1\" class=\"data row9 col1\" >123152</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row9_col2\" class=\"data row9 col2\" >126.000</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row9_col3\" class=\"data row9 col3\" >2.51%</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row9_col4\" class=\"data row9 col4\" >5.64%</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row9_col5\" class=\"data row9 col5\" >1.93%</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row9_col6\" class=\"data row9 col6\" >0.83%</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row9_col7\" class=\"data row9 col7\" >-1.16%</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row9_col8\" class=\"data row9 col8\" >26.17%</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row9_col9\" class=\"data row9 col9\" >2.923</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row9_col10\" class=\"data row9 col10\" >有机硅</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row9_col11\" class=\"data row9 col11\" >润禾材料</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row9_col12\" class=\"data row9 col12\" >11.12%</td>\n",
       "                        <td id=\"T_c2d336da_8a96_11ee_97e7_70a6ccf921e3row9_col13\" class=\"data row9 col13\" >52705.40</td>\n",
       "            </tr>\n",
       "    </tbody></table>"
      ],
      "text/plain": [
       "<pandas.io.formats.style.Styler at 0x24df43c8da0>"
      ]
     },
     "execution_count": 52,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "rank = IncreaseRank()\n",
    "rank_data = rank.api()\n",
    "rank_data.rename(columns=columns_map,inplace=True)\n",
    "# rank_data.style.bar(subset=['现价', '溢价率'], color='#FFA500')\n",
    "# rank_data.style.bar(subset=['price','premium_rt'], color='#FFA500')\n",
    "print(\"按涨幅排序\")\n",
    "rank_data.style.hide_index().format(format_dict).highlight_max(axis=0,subset=['现价'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.0"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 1
}
